MacWorld 1996 July/Macworld (1996-07).dmg/System 7.5 Update 2.0/FileMaker Pro 3.0 CD Extras/FileMaker Templates/Business/Buy versus Lease

FileMaker Pro Database | 1996-01-25 | 95KB | 653 lines

HBAM2016AUG95
Pro 3.0
elcom.newusers! s4958 0
relcom.penpals! s15499 0
relcom.politics! s10414 0
relcom.postmasters! s263 0
relcom.postmasters.d! s12435 0
relcom.rec.tourism! s204 0
relcom.relarn.science! s205 0
relcom.religion! s451 0
relcom.sci.libraries! s287 0
relcom.sci.philosophy! s151 0
relcom.talk! s26617 0
relcom.tcpip! s7075 0
relcom.test! s13228 0
relcom.x! s924 0
resif.admin! s229 1
resif.conferences! s11 0
resif.cuisine! s45 0
resif.culture! s10 0
resif.divers! s1354 1
resif.info.amiga! s37 0
HBAM3016AUG95
Pro 2.0 - 2.1F!
Pro 3.0
    Franz App
AMNT FINANCED
CREATED BY
DATE CREATED
DATE MODIFIED
DOWN PAYMENT
INTEREST RATE
LEASE PRESENT VALUE
LEAST EXPENSIVE
LOAN PERCENT OF VALUE
MONTHLY LEASE PAYMENT
MONTHLY LOAN PAYMENT
MONTHLY RATE
NET PURCHASE PRICE
NUM PERIODS
PRICE END LEASE
PURCHASE PRESENT VALUE
PURCHASE TOTAL PAYMENTS
SCENARIO ID
TERM IN YEARS
TOTAL PAYMENTS
Scenario IDB
Down PaymentB
Net Purchase PriceB
Amnt FinancedB
 <> 0
Interest RateB
Term in YearsB
Date CreatedB
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
1/16/965
Description
You can use this file to analyze relative costs and determine whether to buy or lease an item.  Enter the data and the database performs the calculations.
How to use this solution
Experiment with different down payments or loan/lease terms (in years) to see how changes in those values can affect your decision.
How to customize this solution
Present the information graphically by exporting the data from the file and using it to create a chart in ClarisWorks or ClarisImpact.
"AxA    Form View
A    List View
Buy vs. Lease Summary
Information
Report Menu
A    Form ViewB
Date ModifiedB
Monthly Loan PaymentB
) <> 0
 2 )
Loan Percent of ValueB
Monthly Lease PaymentB
Price End LeaseB
Purchase Total PaymentsB
) <> 0
Total PaymentsB
Purchase Present ValueB
) <> 0
))) +
Lease Present ValueB
! * (((1 +
() ^
) - 1) /
()) / ((1 +
() ^
Monthly RateB
 / 100 / 12
Num PeriodsB
 * 12
ItemB
Least ExpensiveB
 "Purchase"
 "Lease"
 "No Difference"))
Purchase
Lease
No Difference22
InfoB
Created ByB
A    List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Buttonx
Your Own
Buttony
Recordz
Delete
Record{
Record|
Reports}
View As
List~
View As
Close
Least Expensive
Present Value:
Total Payments:
Purchase Price at End of Lease:
Monthly Payment:
Term (years):
Interest Rate:
Loan as % of Value:
Amount Financed:
Down Payment:
Net Purchase Price:
Lease
Purchase
P%Enter data for Buy vs. Lease scenario
Buy vs. Lease SummaryB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Least ExpensiveY
Lease PVZ    Purch. PV[
Lease Ttl.\
Purch. Ttl.]
Item^
Your Own
Button_
Your Own
Button`
Recorda
Delete
Recordb
Recordc
Reportsd
View As
Liste
View As
Formf
Closeg
Infoh9Click to see more information for a Buy versus Lease item
utton`
Recorda
Delete
Recordb
Recordc
Reportsd
View As
Liste
View As
Formf
Closeg
Infoh9Click to see more information for a Buy versus Lease item
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Buttonx
Reportsy
View As
Listz
View As
Form{
Close|
Info}
Page ##
Buy vs. Lease Summary
Purchase
Present Value
Lease
Purchase
Total Payments
Lease
Least
Expensive
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO,Information about the Buy vs. Lease solutionP
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Buy vs. Lease
SummaryE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
) = 400
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Cancel
JmYou did not enter any find criteria; all records will be displayed.C+
) = 0
Cancel
JmNo records match this request.E+
) = 1
Sort by Item
Buy vs. Lease Summary
Open Script
Sort by Item
Buy vs. Lease Summary
Open Script
) = 400
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
Ejwwg
wwxwwxw
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%Q
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww